Statistics for Maintenance Modelling: Continuous Lifetime Distributions 2

# Calculating the Lognormal Distribution Using Excel¤

The Excel function:

LOG NORMDIST(x, mean, standard_dev)

calculates the cumulative distribution for the lognormal. The parameters of this Excel function are:

- x corresponds to t in our notation
- mean corresponds to in our notation
- standard_dev corresponds to in our notation

The inverse of the cumulative distribution function is given by the Excel function:

LOGINV(probability, mean, standard_dev)

Although Excel does not provide a function for calculating the probability density function, it can be easily calculated using Excel's EXP() and LN() functions.

Close